package com.sls.nzdapplication.myapp;



import com.sls.nzdapplication.R;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 常量类，包括导出excle模板
 * */
public class ZDAPP {

    public static final String EQUIPMENT_BDZ = "变电站";

    public static final String EQUIPMENT_DXG = "杆塔";

    public static final String EQUIPMENT_DLQ = "开关";

    public static final String EQUIPMENT_DZ = "电站";

    public static final String EQUIPMENT_GYB = "公用变";

    public static final String EQUIPMENT_BYQ = "配电箱";

    public static final String EQUIPMENT_FZX = "分支箱";

    public static final String EQUIPMENT_DY = "低压";

    public static final String EQUIPMENT_QZJ = "墙支架";

    public static final String EQUIPMENT_QD = "拐点";

    public static final String EQUIPMENT_DB = "表箱";
    public static final String EQUIPMENT_DLJ = "电缆井";


    public static final List<String> kgType = new ArrayList<>();
    static {
        kgType.add("柱上负荷开关");
        kgType.add("跌落式熔断器");
        kgType.add("断路器");
        kgType.add("隔离开关");
    }

    public static final List<String> eqType = new ArrayList<>();
    static {
        eqType.add("环网柜");
        eqType.add("分支箱");
        eqType.add("开关站");
        eqType.add("开闭所");
        eqType.add("配电室");
        eqType.add("箱变");
    }

    public static final List<String> gybType = new ArrayList<>();
    static {
        gybType.add("公用配电变压器");
        gybType.add("公用柱上变压器");
        gybType.add("用户专变");
    }


    public static final Map<String,String> EquipmentTypeName=new HashMap<String,String>();
    static {
        EquipmentTypeName.put(EQUIPMENT_BYQ,"byq");
        EquipmentTypeName.put(EQUIPMENT_FZX,"fzx");
        EquipmentTypeName.put(EQUIPMENT_DY,"tower");
        EquipmentTypeName.put(EQUIPMENT_QD,"gd");
        EquipmentTypeName.put(EQUIPMENT_QZJ,"qzj");
    }

    public static final Map<String,String> EquipmentTypeName2=new HashMap<String,String>();
    static {
        EquipmentTypeName2.put(EQUIPMENT_BYQ,"pdx");
        EquipmentTypeName2.put("变压器","byq");
        EquipmentTypeName2.put(EQUIPMENT_FZX,"fzx");
        EquipmentTypeName2.put(EQUIPMENT_DY,"运行杆塔");
        EquipmentTypeName2.put(EQUIPMENT_QD,"gd");
        EquipmentTypeName2.put(EQUIPMENT_QZJ,"墙支架");
        EquipmentTypeName2.put(EQUIPMENT_DLJ,"电缆井");
    }
    public static final Map<String,String> ZYEquipmentTypeName=new HashMap<String,String>();
    static {
        ZYEquipmentTypeName.put(EQUIPMENT_BDZ,"bdz");
        ZYEquipmentTypeName.put("跌落式熔断器","zy_dlskg");
        ZYEquipmentTypeName.put("柱上负荷开关","zy_zskg");
        ZYEquipmentTypeName.put("断路器","zy_zskg");
        ZYEquipmentTypeName.put("杆塔","tower");
        ZYEquipmentTypeName.put("隔离开关","zy_zskg");
        ZYEquipmentTypeName.put("分支箱","zy_xb");
        ZYEquipmentTypeName.put("环网柜","zy_hwg");
        ZYEquipmentTypeName.put("开关站","zy_kgz");
        ZYEquipmentTypeName.put("开闭所","zy_kbs");
        ZYEquipmentTypeName.put("配电室","zy_pds");
        ZYEquipmentTypeName.put("箱变","zy_xb");
        ZYEquipmentTypeName.put("公用配电变压器","zy_gybyq");
        ZYEquipmentTypeName.put("公用柱上变压器","zy_gybyq");
        ZYEquipmentTypeName.put("用户专变","zy_gybyq");
    }



    public static final Map<String,Integer> EquipmentMapDrawable=new HashMap<String,Integer>();
    static {
        EquipmentMapDrawable.put("Area", R.drawable.area);
        EquipmentMapDrawable.put("Area-p", R.drawable.area);
        EquipmentMapDrawable.put("Area-c", R.drawable.area);
        EquipmentMapDrawable.put("Area-d", R.drawable.area);
        EquipmentMapDrawable.put("变电站",R.drawable.bdzmap);
        EquipmentMapDrawable.put("SubstationLine",R.drawable.substationline);
        EquipmentMapDrawable.put("CableSection-fix",R.drawable.cablesection);
        EquipmentMapDrawable.put("CableSection",R.drawable.cablesection);
        EquipmentMapDrawable.put("Equipment-fix",R.drawable.equipment);
        EquipmentMapDrawable.put("Transformer-fix",R.drawable.transformer);
        EquipmentMapDrawable.put("公用配电变压器",R.drawable.transformer);
        EquipmentMapDrawable.put("高压用户点",R.drawable.gyyhd);
        EquipmentMapDrawable.put("公用柱上变压器",R.drawable.transformer);
        EquipmentMapDrawable.put("用户专变",R.drawable.transformer);
        EquipmentMapDrawable.put("BranchBox-fix",R.drawable.branch_box);
        EquipmentMapDrawable.put("分支箱",R.drawable.branch_box_new);
        EquipmentMapDrawable.put("RingBox-fix",R.drawable.ring_box);
        EquipmentMapDrawable.put("环网柜",R.drawable.ring_box);
        EquipmentMapDrawable.put("Tower-fix", R.drawable.tower);
        EquipmentMapDrawable.put("杆塔",R.drawable.tower_new);
        EquipmentMapDrawable.put("低压",R.drawable.bdzmap);
        EquipmentMapDrawable.put("墙支架",R.drawable.qzj);
        EquipmentMapDrawable.put("SwitchStation-fix",R.drawable.switch_station);
        EquipmentMapDrawable.put("柱上负荷开关",R.drawable.switch_station_new);
        EquipmentMapDrawable.put("跌落式熔断器",R.drawable.dlskg);
        EquipmentMapDrawable.put("断路器",R.drawable.switch_station_new);
        EquipmentMapDrawable.put("隔离开关",R.drawable.switch_station_new);
        EquipmentMapDrawable.put("开关站",R.drawable.switch_station_new);
        EquipmentMapDrawable.put("箱变",R.drawable.switch_station_new);
        EquipmentMapDrawable.put("ElectricityRoom-fix",R.drawable.electricity_room);
        EquipmentMapDrawable.put("配电室",R.drawable.electricity_room_new);
        EquipmentMapDrawable.put("配电箱",R.drawable.electricity_room_new);
        EquipmentMapDrawable.put("变压器",R.drawable.transformer);
        EquipmentMapDrawable.put("电缆井",R.drawable.well);
        EquipmentMapDrawable.put("CompactSubstation-fix",R.drawable.compact_substation);
        EquipmentMapDrawable.put("开闭所",R.drawable.compact_substation_new);
        EquipmentMapDrawable.put("Virtual-fix",R.drawable.virtual);
        EquipmentMapDrawable.put("Virtual",R.drawable.virtual);
        EquipmentMapDrawable.put("DlWay-fix",R.drawable.road);
        EquipmentMapDrawable.put("DlWay",R.drawable.road);
        EquipmentMapDrawable.put("CableWell-fix",R.drawable.cable_well);
        EquipmentMapDrawable.put("CableWell",R.drawable.cable_well);
        EquipmentMapDrawable.put("Channel-fix",R.drawable.channel);
        EquipmentMapDrawable.put("Channel",R.drawable.channel);
        EquipmentMapDrawable.put("拐点",R.drawable.cable_connector);
        EquipmentMapDrawable.put("Surplus",R.drawable.surplus);
        EquipmentMapDrawable.put("TurningPoint-fix",R.drawable.turning_point);
        EquipmentMapDrawable.put("TurningPoint",R.drawable.turning_point_map);
    }

    public static final String[] EXCEL_DYMB_SHEET = {"1.低压杆塔","2.低压导线","10.低压墙支模板","11.用户接入点模板","12.接户线","13.低压点设备电缆分支箱","14.低压电缆段","15.低压电缆终端"};


    public static final String[] EXCEL_ZYMB_SHEET = {"杆塔及隐患缺陷类型核查表","柱上变、开关、配电站房等设备核查表"};

    public static final Map<Integer,String[]> ZY_MODEL_TITLE=new HashMap<Integer,String[]>();
    static {
        ZY_MODEL_TITLE.put(0,new String[]{"序号","设备名称","所属线路","杆塔材质","设备类型","杆塔性质","杆塔型号","是否终端","经度","纬度","隐患","缺陷情况","数量","线路巡视检查人员","长度(m)"});
        ZY_MODEL_TITLE.put(1,new String[]{"序号","设备名称","设备类型","设备状态","所属馈线","资产状态","设备型号","变压器额定容量(kVA)","现场所在杆号","现场开合闸情况","缺陷情况","异常原因","经度","纬度"});
    }

    public static final Map<Integer,String[]> MODEL_TITLE=new HashMap<Integer,String[]>();
    static {
        MODEL_TITLE.put(0,new String[]{"序号","SBID","设备名称","运行编号","设备关联ID","杆塔性质","经度（X坐标）",
                "纬度（Y坐标）","回路信息","杆塔材质","所属地市","运维单位","同杆架设类型","系统是否存在",
                "所属物理杆塔ID","维护班组","同杆架设回路数","运投日期","档距（m）","转角方向","转角度数","设备状态",
                "型号","生产厂家","出厂日期","横担材料","杆高（m）","基础形式","接地电阻（Ω）","施工单位","备注","是否终端","是否同杆架设"});
        MODEL_TITLE.put(1,new String[]{"序号","SBID","设备名称","运行编号","起始杆塔类型","起始杆塔ID","过程杆塔",
                "终止杆塔类型","终止杆塔ID","所属地市","运维单位","运投日期","设备状态",
                "型号","生产厂家","导线规格","导线长度（m）","安全系数","备注","维护班组","所属线路层数"});
        MODEL_TITLE.put(2,new String[]{"序号","SBID","设备名称","设备关联ID","运行编号","所属地市","运维单位","经度（X坐标）","纬度（Y坐标）",
                "设备状态"});
        MODEL_TITLE.put(3,new String[]{"序号","SBID","设备名称","运行编号","设备关联ID","经度（X坐标）","纬度（Y坐标）","所属地市","运维单位",
                "维护班组","设备状态"});
        MODEL_TITLE.put(4,new String[]{"序号","SBID","设备名称","运行编号","起始杆塔类型","起始杆塔ID",
                "终止杆塔类型","终止杆塔ID","所属地市","运维单位","运投日期","设备状态",
                "型号","生产厂家","导线规格","所属线路","安全系数","备注","线类型"});
        MODEL_TITLE.put(5,new String[]{"序号","SBID","设备名称","运行编号","所属地市","运维单位",
                "经度（X坐标）","纬度（Y坐标）","维护班组","设备类型","投运日期","设备状态",
                "资产性质","资产单位","型号","生产厂家","出厂编号","出厂日期","额定电压","额定电流","备注"});
        MODEL_TITLE.put(6,new String[]{"序号","SBID","设备名称","运行编号","起点设备类型","起点设备ID",
                "终点设备类型","终点设备ID","电缆拐点","所属地市","运维单位","维护班组",
                "投运日期","设备状态","型号","生产厂家","出厂编号","出厂日期","长度","额定电压(V)","绝缘类型","电缆截面(mm2)","额定载流量(A)","线芯材料","芯数","备注"});
        MODEL_TITLE.put(7,new String[]{"序号","SBID","设备名称","运行编号","设备关联ID","经度（X坐标）",
                "纬度（Y坐标）","所属地市","运维单位","安装位置","终端类型","投运日期",
                "设备状态","型号","生产厂家","出厂编号","出厂日期","制作单位","制作人","备 注"});
    }

    public static final Map<Integer,String[]> MODEL_EXPLANATION=new HashMap<Integer,String[]>();
    static {
        MODEL_EXPLANATION.put(0,new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "必填字段",
                "必填字段",
                "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立后续各线路设备与杆塔关联关系",
                "耐张,直线",
                "必填字段",
                "必填字段",
                "填写数字，正数表示右回，例如2表示右二回；负数表示左回，例如-2表示左二回；0表示中回。","角钢塔,钢管塔,钢管杆,水泥杆,铁杆,木杆,其他",
                "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "无并架;同压并架；高低压并架",
                "是，否",
                "当“系统是否已存在”列中的值为“是”，该处填写运行杆所在物理杆的SBID值",
                "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "",
                "",
                "必填字段",
                "",
                "",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "",
                "",
                "",
                "",
                "",
                "",
                "是,否",
                "是,否"});
        MODEL_EXPLANATION.put(1,new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "必填字段",
                "选填字段",
                "运行杆塔，墙支架",
                "必填字段，与杆塔表中的“设备关联ID”相对应，通过该字段值可以在杆塔表中找到对应的杆塔",
                "可填字段，与杆塔、墙支架表中的“设备关联ID”相对应，通过该字段值可以在杆塔、墙支架表中找到对应的设备。填写格式为：设备关联ID，类型标识。其中类型标识有两种，01表示运行杆塔，02表示墙支架。多个设备间用分号相隔",
                "运行杆塔，墙支架",
                "必填字段，与杆塔表中的“设备关联ID”相对应，通过该字段值可以在杆塔表中找到对应的杆塔",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据x",
                "",
                "",
                "",
                "",
                "",
                "",
                "",
                "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                ""});
        MODEL_EXPLANATION.put(2,new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "必填字段",
                "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立后续各线路设备与墙支架关联关系",
                "选填字段",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "必填字段",
                "必填字段",
                "必填字段"});
        MODEL_EXPLANATION.put(3, new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "",
                "选填字段",
                "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立其他设备与接入点的关联关系",
                "必填字段",
                "必填字段",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "",
                ""});
        MODEL_EXPLANATION.put(4,new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "必填字段",
                "必填字段",
                "运行杆塔,墙支架,电缆终端",
                "必填字段，与杆塔表或电缆终端表中的“设备关联ID”相对应，通过该字段值可以在杆塔表中找到对应的杆塔或者电缆终端",
                "用户接入点",
                "必填字段，与用户接入点表中的“设备关联ID”相对应，通过该字段值可以在用户接入点表中找到对应的杆塔",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据x",
                "必填字段",
                "",
                "",
                "",
                "",
                "",
                "",
                "必填字段\n" +
                        "1、若起始点设备类型为杆塔或者墙支架，则生成线的类型按此列中的值来定义\n" +
                        "2、若起始点设备类型为电缆终端，则无论此列是什么值，生成的线都是连接线"});
        MODEL_EXPLANATION.put(5,new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "必填字段",
                "选填字段",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "必填字段",
                "必填字段",
                "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "",
                "",
                "请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "",
                "",
                "",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "",
                "",
                ""
        });
        MODEL_EXPLANATION.put(6,new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "",
                "选填字段",
                "电缆终端，电缆接头",
                "必填字段，与电缆终端或者电缆接头表中的“设备关联ID”相对应，通过该字段值可以在相应的电缆终端或者电缆接头表中查询到唯一的对应记录",
                "电缆终端，电缆接头",
                "必填字段，与电缆终端或者电缆接头表中的“设备关联ID”相对应，通过该字段值可以在相应的电缆终端或者电缆接头表中查询到唯一的对应记录",
                "填写电缆段除了起点、终点以外各个点的坐标，坐标对之间用英文分号分隔，坐标对内部的x，y坐标间用逗号分隔，例如x1,y1;x2,y2;x3,y3;……;xn,yn;",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的运维班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "必填字段",
                "",
                "",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "",
                "",
                "",
                "",
                "",
                "",
                "",
                "",
                ""});
        MODEL_EXPLANATION.put(7,new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
                "非用户填写字段，由系统功能生成该字段值",
                "",
                "选填字段",
                "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立后续各线路设备与电缆终端的关联关系",
                "必填字段",
                "必填字段",
                "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "可以不填，那么导入后设备的运维单位默认为登录客户端时所选的运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
                "",
                "",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "必填字段",
                "",
                "",
                "",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
                "",
                ""});
    }


    //1.低压杆塔
    public static String[] EXCEL_TITLE_DYMB_DYGT = new String[]{"序号","SBID","设备名称","运行编号","设备关联ID","杆塔性质","经度（X坐标）",
            "纬度（Y坐标）","回路信息","杆塔材质","所属地市","运维单位","同杆架设类型","系统是否存在",
            "所属物理杆塔ID","维护班组","同杆架设回路数","运投日期","档距（m）","转角方向","转角度数","设备状态",
            "型号","生产厂家","出厂日期","横担材料","杆高（m）","基础形式","接地电阻（Ω）","施工单位","备注","是否终端","是否同杆架设"};

    //1.低压杆塔说明
    public static String[] EXCEL_ROW1_DYMB_DYGT = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "必填字段",
            "必填字段",
            "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立后续各线路设备与杆塔关联关系",
            "耐张,直线",
            "必填字段",
            "必填字段",
            "填写数字，正数表示右回，例如2表示右二回；负数表示左回，例如-2表示左二回；0表示中回。","角钢塔,钢管塔,钢管杆,水泥杆,铁杆,木杆,其他",
            "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "无并架;同压并架；高低压并架",
            "是，否",
            "当“系统是否已存在”列中的值为“是”，该处填写运行杆所在物理杆的SBID值",
            "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "",
            "",
            "必填字段",
            "",
            "",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "",
            "",
            "",
            "",
            "",
            "",
            "是,否",
            "是,否"};


    //2.低压导线
    public static String[] EXCEL_TITLE_DYMB_DYDX = new String[]{"序号","SBID","设备名称","运行编号","起始杆塔类型","起始杆塔ID","过程杆塔",
            "终止杆塔类型","终止杆塔ID","所属地市","运维单位","运投日期","设备状态",
            "型号","生产厂家","导线规格","导线长度（m）","安全系数","备注","维护班组","所属线路层数"};

    //2.低压导线说明
    public static String[] EXCEL_ROW1_DYMB_DYDX = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "必填字段",
            "选填字段",
            "运行杆塔，墙支架",
            "必填字段，与杆塔表中的“设备关联ID”相对应，通过该字段值可以在杆塔表中找到对应的杆塔",
            "可填字段，与杆塔、墙支架表中的“设备关联ID”相对应，通过该字段值可以在杆塔、墙支架表中找到对应的设备。填写格式为：设备关联ID，类型标识。其中类型标识有两种，01表示运行杆塔，02表示墙支架。多个设备间用分号相隔",
            "运行杆塔，墙支架",
            "必填字段，与杆塔表中的“设备关联ID”相对应，通过该字段值可以在杆塔表中找到对应的杆塔",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据x",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            ""};

    //10.低压墙支模板
    public static String[] EXCEL_TITLE_DYMB_DYQZ = new String[]{"序号","SBID","设备名称","设备关联ID","运行编号","所属地市","运维单位","经度（X坐标）","纬度（Y坐标）",
            "设备状态"};

    //10.低压墙支模板说明
    public static String[] EXCEL_ROW1_DYMB_DYQZ = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "必填字段",
            "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立后续各线路设备与墙支架关联关系",
            "选填字段",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "必填字段",
            "必填字段",
            "必填字段"};


    //11.用户接入点模板
    public static String[] EXCEL_TITLE_DYMB_YHJRD = new String[]{"序号","SBID","设备名称","运行编号","设备关联ID","经度（X坐标）","纬度（Y坐标）","所属地市","运维单位",
            "维护班组","设备状态"};

    //11.用户接入点模板说明
    public static String[] EXCEL_ROW1_DYMB_YHJRD = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "",
            "选填字段",
            "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立其他设备与接入点的关联关系",
            "必填字段",
            "必填字段",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "",
            ""};

    //12.接户线
    public static String[] EXCEL_TITLE_DYMB_JHX = new String[]{"序号","SBID","设备名称","运行编号","起始杆塔类型","起始杆塔ID",
            "终止杆塔类型","终止杆塔ID","所属地市","运维单位","运投日期","设备状态",
            "型号","生产厂家","导线规格","所属线路","安全系数","备注","线类型"};

    //12.接户线说明
    public static String[] EXCEL_ROW1_DYMB_JHX = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "必填字段",
            "必填字段",
            "运行杆塔,墙支架,电缆终端",
            "必填字段，与杆塔表或电缆终端表中的“设备关联ID”相对应，通过该字段值可以在杆塔表中找到对应的杆塔或者电缆终端",
            "用户接入点",
            "必填字段，与用户接入点表中的“设备关联ID”相对应，通过该字段值可以在用户接入点表中找到对应的杆塔",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据x",
            "必填字段",
            "",
            "",
            "",
            "",
            "",
            "",
            "必填字段\n" +
                    "1、若起始点设备类型为杆塔或者墙支架，则生成线的类型按此列中的值来定义\n" +
                    "2、若起始点设备类型为电缆终端，则无论此列是什么值，生成的线都是连接线"};



    //13.低压点设备电缆分支箱
    public static String[] EXCEL_TITLE_DYMB_DYDSBDLFZX = new String[]{"序号","SBID","设备名称","运行编号","所属地市","运维单位",
            "经度（X坐标）","纬度（Y坐标）","维护班组","设备类型","投运日期","设备状态",
            "资产性质","资产单位","型号","生产厂家","出厂编号","出厂日期","额定电压","额定电流","备注"};

    //13.低压点设备电缆分支箱说明
    public static String[] EXCEL_ROW1_DYMB_DYDSBDLFZX = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "必填字段",
            "选填字段",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "必填字段",
            "必填字段",
            "可以不填，那么导入后设备的维护班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "",
            "",
            "请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "",
            "",
            "",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "",
            "",
            ""
    };

    //14.低压电缆段
    public static String[] EXCEL_TITLE_DYMB_DYDLD = new String[]{"序号","SBID","设备名称","运行编号","起点设备类型","起点设备ID",
            "终点设备类型","终点设备ID","电缆拐点","所属地市","运维单位","维护班组",
            "投运日期","设备状态","型号","生产厂家","出厂编号","出厂日期","长度","额定电压(V)","绝缘类型","电缆截面(mm2)","额定载流量(A)","线芯材料","芯数","备注"};

    //14.低压电缆段说明
    public static String[] EXCEL_ROW1_DYMB_DYDLD = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "",
            "选填字段",
            "电缆终端，电缆接头",
            "必填字段，与电缆终端或者电缆接头表中的“设备关联ID”相对应，通过该字段值可以在相应的电缆终端或者电缆接头表中查询到唯一的对应记录",
            "电缆终端，电缆接头",
            "必填字段，与电缆终端或者电缆接头表中的“设备关联ID”相对应，通过该字段值可以在相应的电缆终端或者电缆接头表中查询到唯一的对应记录",
            "填写电缆段除了起点、终点以外各个点的坐标，坐标对之间用英文分号分隔，坐标对内部的x，y坐标间用逗号分隔，例如x1,y1;x2,y2;x3,y3;……;xn,yn;",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的运维班组默认为登录用户所在的班组;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "必填字段",
            "",
            "",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            "",
            ""};

    //15.低压电缆终端
    public static String[] EXCEL_TITLE_DYMB_DYDLZD = new String[]{"序号","SBID","设备名称","运行编号","设备关联ID","经度（X坐标）",
            "纬度（Y坐标）","所属地市","运维单位","安装位置","终端类型","投运日期",
            "设备状态","型号","生产厂家","出厂编号","出厂日期","制作单位","制作人","备 注"};

    //15.低压电缆终端说明
    public static String[] EXCEL_ROW1_DYMB_DYDLZD = new String[]{"必填字段，可以自动生成，用于导入日志提示问题数据",
            "非用户填写字段，由系统功能生成该字段值",
            "",
            "选填字段",
            "必填字段，可由excel自动生成，在当前页中必须保证每个值的唯一性，用于建立后续各线路设备与电缆终端的关联关系",
            "必填字段",
            "必填字段",
            "可以不填，那么导入后设备的所属地市默认为登录客户端时所选地市;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "可以不填，那么导入后设备的运维单位默认为登录客户端时所选的运维单位;如果填写，请填写ISC_SPECIALORG_UNIT_LOCEXT表中对应单位的ISC_ID值",
            "",
            "",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "必填字段",
            "",
            "",
            "",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "日期填写格式为：xxxx-xx-xx；填写完成以后表格自动设置为日期格式，显示内容为2015/12/12 为正确数据",
            "",
            ""};

}
